package com.momo.mapper.mapper;

import com.momo.mapper.dataobject.UserInfoDO;
import org.apache.ibatis.annotations.Param;

/**
 * 由于需要对分页支持,请直接使用对应的DAO类
 * 注意:此结构有系统生成,禁止手工修改,以免被覆盖,请通过dalgen生成
 * The Table USER_INFO.
 * USER_INFO
 */
public interface UserInfoDOMapper{

    /**
     * desc:插入表:USER_INFO.<br/>
     * descSql =  SELECT LAST_INSERT_ID() INSERT INTO USER_INFO( NAME ,TELPHONE ,REGISTER_MODE ,THIRD_PARTY_ID ,AGE ,GENDER )VALUES( #{name,jdbcType=VARCHAR} ,#{telphone,jdbcType=VARCHAR} ,#{registerMode,jdbcType=VARCHAR} ,#{thirdPartyId,jdbcType=VARCHAR} ,#{age,jdbcType=INTEGER} ,#{gender,jdbcType=TINYINT} )
     * @param entity entity
     * @return int
     */
    int insert(UserInfoDO entity);
    /**
     * desc:更新表:USER_INFO.<br/>
     * descSql =  UPDATE USER_INFO SET NAME = #{name,jdbcType=VARCHAR} ,TELPHONE = #{telphone,jdbcType=VARCHAR} ,REGISTER_MODE = #{registerMode,jdbcType=VARCHAR} ,THIRD_PARTY_ID = #{thirdPartyId,jdbcType=VARCHAR} ,AGE = #{age,jdbcType=INTEGER} ,GENDER = #{gender,jdbcType=TINYINT} WHERE ID = #{id,jdbcType=INTEGER}
     * @param entity entity
     * @return int
     */
    int update(UserInfoDO entity);
    /**
     * desc:根据主键删除数据:USER_INFO.<br/>
     * descSql =  DELETE FROM USER_INFO WHERE ID = #{id,jdbcType=INTEGER}
     * @param id id
     * @return int
     */
    int deleteById(Integer id);
    /**
     * desc:根据主键获取数据:USER_INFO.<br/>
     * descSql =  SELECT * FROM USER_INFO WHERE ID = #{id,jdbcType=INTEGER}
     * @param id id
     * @return UserInfoDO
     */
    UserInfoDO getById(Integer id);
}
